Inrix provided PSRC data for May 2019 freight movements. The data includes the following:
The following analysis includes Port of Seattle terminals (T-5, T-18, and T-30) as well as Port of Tacoma terminals (PCT, Husky, and WUT). For each terminals, we calculated number of trips originated and ended in the terminal, median trip length, and O-D maps.
The following is a head of Trips data that we work with
| TripId | DeviceId | ProviderId | Mode | StartDate | StartWDay | EndDate | EndWDay | StartLocLat | StartLocLon | EndLocLat | EndLocLon | GeospatialType | ProviderType | ProviderDrivingProfile | VehicleWeightClass | ProbeSourceType | OriginZoneName | DestinationZoneName | EndpointType | TripMeanSpeedKph | TripMaxSpeedKph | TripDistanceMeters | MovementType | OriginCbg | DestCbg | StartTimezone | EndTimezone | WaypointFreqSec | StartQk | EndQk | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | a58741e59c39b039c50101f68d292349 | d422c29ef06ec8dc7a3ad73858c1c70e | f033ab37c30201f73f142449d037028d | 1 | 2019-05-20T22:53:34.034Z | 1 | 2019-05-20T23:02:03.003Z | 1 | 48.00010 | -122.11590 | 48.00040 | -122.12720 | II | 2 | 3 | 2 | 1 | SNOHOMISH | SNOHOMISH | 2 | 26.55501 | 54.34535 | 3754.35425 | 1 | nan | nan | America/Los_Angeles | America/Los_Angeles | 46.26991 | 21230012232320301 | 21230012232231301 |
| 1 | e574a35bb513e4981424188726e9662a | 1992ccba0a2d60701d03880371fdde6c | f033ab37c30201f73f142449d037028d | 1 | 2019-05-20T23:59:59.059Z | 1 | 2019-05-21T00:05:29.029Z | 1 | 48.05450 | -122.18760 | 48.07670 | -122.18780 | II | 2 | 3 | 2 | 1 | SNOHOMISH | SNOHOMISH | 3 | 38.94926 | 94.14665 | 3570.02448 | 1 | nan | nan | America/Los_Angeles | America/Los_Angeles | 12.69115 | 21230012221332003 | 21230012221310003 |
| 2 | fc7f4fe52cb94479ae9f7e5f6702e4de | 93f7fc1ffabe1538010794e907f1703f | 54229abfcfa5649e7003b83dd4755294 | 1 | 2019-05-21T15:22:48.048Z | 2 | 2019-05-21T15:24:27.027Z | 2 | 47.23850 | -122.36820 | 47.23450 | -122.36450 | II | 2 | 3 | 2 | 1 | PIERCE | PIERCE | 2 | 19.75635 | 21.54136 | 543.18440 | 1 | nan | nan | America/Los_Angeles | America/Los_Angeles | 24.74475 | 21230023311303132 | 21230023311312222 |
| 3 | 88ed8f34f208ec74ff05272fd57ebe12 | fcc676d1dc8eeececfc8251a08a47913 | 54229abfcfa5649e7003b83dd4755294 | 1 | 2019-05-21T19:36:31.031Z | 2 | 2019-05-21T20:06:33.033Z | 2 | 47.45350 | -122.22330 | 47.20980 | -122.30030 | II | 2 | 3 | 2 | 1 | KING | PIERCE | 3 | 66.46061 | 95.82042 | 33267.26431 | 1 | nan | nan | America/Los_Angeles | America/Los_Angeles | 78.34791 | 21230032003010311 | 21230032202013131 |
| 4 | 1e9e9c070524cb976e5be7a0009197bb | fba11305da03375db0e7d26e2d69dcf5 | f033ab37c30201f73f142449d037028d | 1 | 2019-05-21T22:12:30.030Z | 2 | 2019-05-21T22:22:29.029Z | 2 | 47.91830 | -122.10910 | 47.93590 | -122.07960 | II | 2 | 3 | 2 | 1 | SNOHOMISH | SNOHOMISH | 3 | 28.00660 | 84.24780 | 4659.97910 | 1 | nan | nan | America/Los_Angeles | America/Los_Angeles | 59.89990 | 21230030012103212 | 21230030011222020 |
C:\Users\pbutrina\AppData\Local\Continuum\anaconda3\envs\myenv\lib\site-packages\pyproj\crs\crs.py:53: FutureWarning: '+init=<authority>:<code>' syntax is deprecated. '<authority>:<code>' is the preferred initialization method. When making the change, be mindful of axis order changes: https://pyproj4.github.io/pyproj/stable/gotchas.html#axis-order-changes-in-proj-6
There are 577 trips originated in the terminal There are 529 trips ended in the terminal The median distance of trip originated in the terminal is 3.66 miles The median distance of trip ended in the terminal is 2.74 miles
C:\Users\pbutrina\AppData\Local\Continuum\anaconda3\envs\myenv\lib\site-packages\pyproj\crs\crs.py:53: FutureWarning: '+init=<authority>:<code>' syntax is deprecated. '<authority>:<code>' is the preferred initialization method. When making the change, be mindful of axis order changes: https://pyproj4.github.io/pyproj/stable/gotchas.html#axis-order-changes-in-proj-6
There are 6526 trips originated in the terminal There are 5618 trips ended in the terminal The median distance of trip originated in the terminal is 14.39 miles The median distance of trip ended in the terminal is 8.02 miles
C:\Users\pbutrina\AppData\Local\Continuum\anaconda3\envs\myenv\lib\site-packages\pyproj\crs\crs.py:53: FutureWarning: '+init=<authority>:<code>' syntax is deprecated. '<authority>:<code>' is the preferred initialization method. When making the change, be mindful of axis order changes: https://pyproj4.github.io/pyproj/stable/gotchas.html#axis-order-changes-in-proj-6
There are 349 trips originated in the terminal There are 324 trips ended in the terminal The median distance of trip originated in the terminal is 2.59 miles The median distance of trip ended in the terminal is 2.91 miles
C:\Users\pbutrina\AppData\Local\Continuum\anaconda3\envs\myenv\lib\site-packages\pyproj\crs\crs.py:53: FutureWarning: '+init=<authority>:<code>' syntax is deprecated. '<authority>:<code>' is the preferred initialization method. When making the change, be mindful of axis order changes: https://pyproj4.github.io/pyproj/stable/gotchas.html#axis-order-changes-in-proj-6
There are 458 trips originated in the terminal There are 442 trips ended in the terminal The median distance of trip originated in the terminal is 4.73 miles The median distance of trip ended in the terminal is 0.76 miles
C:\Users\pbutrina\AppData\Local\Continuum\anaconda3\envs\myenv\lib\site-packages\pyproj\crs\crs.py:53: FutureWarning: '+init=<authority>:<code>' syntax is deprecated. '<authority>:<code>' is the preferred initialization method. When making the change, be mindful of axis order changes: https://pyproj4.github.io/pyproj/stable/gotchas.html#axis-order-changes-in-proj-6
There are 888 trips originated in the terminal There are 622 trips ended in the terminal The median distance of trip originated in the terminal is 2.55 miles The median distance of trip ended in the terminal is 0.77 miles
C:\Users\pbutrina\AppData\Local\Continuum\anaconda3\envs\myenv\lib\site-packages\pyproj\crs\crs.py:53: FutureWarning: '+init=<authority>:<code>' syntax is deprecated. '<authority>:<code>' is the preferred initialization method. When making the change, be mindful of axis order changes: https://pyproj4.github.io/pyproj/stable/gotchas.html#axis-order-changes-in-proj-6
There are 1004 trips originated in the terminal There are 957 trips ended in the terminal The median distance of trip originated in the terminal is 0.97 miles The median distance of trip ended in the terminal is 0.62 miles
C:\Users\pbutrina\AppData\Local\Continuum\anaconda3\envs\myenv\lib\site-packages\pyproj\crs\crs.py:53: FutureWarning: '+init=<authority>:<code>' syntax is deprecated. '<authority>:<code>' is the preferred initialization method. When making the change, be mindful of axis order changes: https://pyproj4.github.io/pyproj/stable/gotchas.html#axis-order-changes-in-proj-6
There are 7113 trips originated in the terminal There are 7189 trips ended in the terminal The median distance of trip originated in the terminal is 9.51 miles The median distance of trip ended in the terminal is 9.68 miles
True